Startup and shutdown of db2 database

Under a DB2 instance, you can create multiple database (how many database can be created under each instance, which can be viewed through DB2 GET DBM CFG. Once the database has been established, it can be manipulated. However, after reporting to the database,

2022-06-02 Servers 我要分享

Centos 7 makes Oracle 12c Docker

Resource preparation requires downloading oracle-related things, such as installation files, dockerfile. These can be found on oracle's github. Https://github.com/oracle/docker-ima

2022-06-01 Database 我要分享

ORA-38760: This database instance failed to turn on flashback database

Last night I learned that ORACLE was executed by HR users: create table reg_copy as select * from regions; was a blank without any response, so I didn't want to quit forcibly, so I used ORACLE users to terminate the meeting.

2022-06-01 Database 我要分享

Oracle 10g silent installation

# yum-y install autoconf automake binutils-devel bison cpp dos2unix ftp gcc gcc-c++ lrzsz python-dev

2022-06-01 Database 我要分享

Differences between database name, instance name, database domain name, global database name, service name

The Oracle database first has a database name, and you can also set a domain name. The global database name is actually the database name + domain name. For example, the database is called orcl and the domain name is called abc.co.

2022-06-01 Database 我要分享

How to understand the global database name in Oracle distributed system

Today, I will talk to you about how to understand the global database name in the Oracle distributed system, which may not be well understood by many people. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something from this article. In a distributed system, every database has

2022-05-31 Database 我要分享

How to manage Dataguard on a daily basis

In this issue, the editor will bring you about how to carry out the daily management of Dataguard. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article. Dataguard daily management 1.fail over2

2022-05-31 Database 我要分享

Dealing with Dataguard and rman RMAN-05501

Dataguard Reserve Library recovery Times rman-05501RMAN > duplicate target database for standby;Starting Duplicate Db at 09-JU

2022-06-01 Database 我要分享

MariaDB create, change, delete database command

Create a new MySQL database create a MySQL database with a specific character set (UTF8) Delete an existing MySQL database create a MySQL database only if it does not exist will you lose the database feature that changes db.opt only when the db.opt database exists

2022-06-01 Database 我要分享

The Dataguard environment modifies the online redo log&standby redo log size of the main library and standby database

Current environment: Oracle 11.0.2.4 primary+standby3 group redo log group (200m each). 4 groups of standby redo log plan to modify redo because of the increase in business.

2022-06-01 Database 我要分享

Database name, instance name, database domain name, global database name, service name

Database name, instance name, database domain name, global database name, and service name are several concepts that are easy to confuse for many beginners. I believe that many beginners are as confused as I am by these concepts in the title. Let's figure them out now. 1 what is the database name?

2022-06-01 Database 我要分享

[translation] Specifying CREATE DATABASE Statement Clauses

Specifying CREATE DATABASE Statement ClausesWhen you execute a CREATE DATABASE statement, Oracle Dat

2022-06-01 Database 我要分享

What does the first generation database system mean?

This article mainly introduces the meaning of the first generation database system, which is very detailed and has a certain reference value. Interested friends must finish reading it! The first generation database system refers to the database system based on mesh model or hierarchical model. Database system refers to the computer system

2022-06-02 Internet Technology 我要分享

11g RAC and increase the size and number of log groups

This article introduces 11g RAC and increases the size and number of log groups. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you. Prepare the database and close the log application: SQL > select status from v$inst

2022-05-31 Database 我要分享

Snapshot standby mode

During the incremental production of a production business, the customer found that the database would switch the Snapshot standby mode. Take a learning test. First, the principle shows that in Oracle 11g, data guard is the most attractive real-time active data guard.

2022-06-01 Database 我要分享

Oracle database startup and shutdown

To understand the startup and stop of Oracle databases, you need to understand the definitions of the terms "instance" and "database": database (database): a collection of physical operating system files or disks (disk). Example (

2022-06-01 Database 我要分享

Automatic backup scripts for windows and linux environments

@ echo offecho = = automatic backup script for Oracle database in echo Windows environment echo 1.

2022-06-01 Database 我要分享

Basic knowledge of database

The basic concept of the database is "the warehouse that organizes, stores and manages data according to the data structure". It is a collection of organized, shareable and uniformly managed large amounts of data stored in a computer for a long time. The database is stored together in a certain way, can be shared with multiple users, and can be used as much as possible.

2022-06-03 Servers 我要分享

What is the relationship among database, database system and database management system?

I would like to share with you the relationship among database, database system and database management system. I believe most people don't know much about it, so share this article for your reference. I hope you will gain a lot after reading this article. Let's learn about it! Database, number

2022-06-02 Internet Technology 我要分享

How to set CLUSTER_DATABASE parameters when Oracle RAC starts archiving

This article mainly explains "how to set CLUSTER_DATABASE parameters when Oracle RAC starts archiving". The explanation in this article is simple, clear and easy to learn and understand. now please follow the editor's train of thought to study and learn "Oracl".

2022-05-31 Database 我要分享